﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SqlLiteTest
{
    interface ITestDatabase
    {
        void OpenAndClear();
        void CreateIndividualTable();
        void InsertNewIndividual(int id, string firstname, string middlename, string lastname, DateTime dob, string state);
        IIndividual GetIndividualById(int id);
        void SaveIndividual(IIndividual individual);
        void Close();

        void CreateDobIndex();
        IEnumerable<IIndividual> IndividualsByAge();
        
        void BeginUpdates();

        void EndUpdates();
    }

}
